package KC.b2b.conciliacion.manual;

import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.Connection;

public class CierreConciliacion {


  public void mesSiguiente(Connection conn, int int_conciliacionId) throws
      SQLException {
    String str_conciliacion =
        " SELECT dc.idtxconcilia,             " +
        "        conciliacionid,              " +
        "        comentario,                  " +
        "        CASE                         " +
        "            WHEN tipotransaccion = 1 " +
        "                THEN 'Cargo'         " +
        "                ELSE 'Abono'         " +
        "        END  tipotransaccion,        " +
        "        CASE                         " +
        "            WHEN baanBanco = 1 " +
        "              THEN 'Banco' " +
        "              ELSE 'BaaN' " +
        "        END baanBanco " +
        " FROM arb2_DETALLEconciliaciones dc " +
        " WHERE dc.status = 0 AND conciliacionid = "+int_conciliacionId+" ";

    Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
    ResultSet rs = stmt.executeQuery(str_conciliacion);
    while(rs.next()){

    }
  }

}
